comm
1	42020	ITEM_MALL_FLAG_UPGRADE_SCROLL_1	By Mohamed_habib	xxx	SN_ITEM_MALL_FLAG_UPGRADE_SCROLL_1	SN_ITEM_MALL_FLAG_UPGRADE_SCROLL_1_TT_DESC	1	0	3	3	3	1	180000	3	0	1	1	1	255	0	1	0	0	1	0	0	0	0	0	0	0	-1	0	-1	0	-1	0	-1	0	-1	0	0	0	0	0	0	0	100	0	0	0	xxx	item\etc\drop_mall_scroll.bsr	item\etc\item_fb_avatar.ddj	xxx	xxx	21551

item
21551	1	2	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1000	????	1	??????                                                                                                                           	-1	RESURRECT	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	0	0	0

/////////////////////////
shardlog>>>addlogitem

IF @Operation = '41'  
BEGIN 
    DECLARE @ItemName VARCHAR(100)
    SELECT @ItemName = CodeName128 
    FROM SRO_VT_SHARD.dbo._RefObjCommon 
    WHERE ID = @ItemRefID
---------------------------------------------------------------
IF (@ItemName = 'ITEM_MALL_FLAG_UPGRADE_SCROLL_1')
BEGIN
    UPDATE I
    SET
        -- رفع الليفل
        OptLevel = OptLevel + 1,

        -- عدد الـ MagParams الفعلي
        MagParamNum = CASE OptLevel + 1
            WHEN 1 THEN 2        -- INT, STR
            WHEN 2 THEN 3        -- + Damage
            WHEN 3 THEN 3
            WHEN 4 THEN 3
            WHEN 5 THEN 3
            WHEN 6 THEN 3
            WHEN 7 THEN 4        -- + Ignore
            WHEN 8 THEN 5        -- + Attack Rate
        END,

        -- INT (يزيد لحد 7 ويقف)
        MagParam1 = CASE 
            WHEN OptLevel + 1 >= 7 THEN 30064771150   -- INT 7
            ELSE (OptLevel + 1) * 4294967296 + 78
        END,

        -- STR (يزيد لحد 7 ويقف)
        MagParam2 = CASE 
            WHEN OptLevel + 1 >= 7 THEN 30064771144   -- STR 7
            ELSE (OptLevel + 1) * 4294967296 + 72
        END,

        -- Damage Inc (يزيد تدريجي لحد %5 عند OptLevel 7)
        MagParam3 = CASE
            WHEN OptLevel + 1 = 7 THEN 21474836732    -- Damage %5
            WHEN OptLevel + 1 BETWEEN 2 AND 6
                THEN 4294967548 + ((OptLevel - 1) * 4294967296)
            ELSE MagParam3
        END,

        -- Ignore Monster Defence %1 (يظهر عند OptLevel 7)
        MagParam4 = CASE
            WHEN OptLevel + 1 = 7 THEN 4294967550
            ELSE MagParam4
        END,

        -- Attack Rate %5 (OptLevel 8 فقط)
        MagParam5 = CASE
            WHEN OptLevel + 1 = 8 THEN 21474836728
            ELSE MagParam5
        END
    FROM SRO_VT_SHARD.._Items I
    WHERE I.ID64 IN (
        SELECT ItemID
        FROM SRO_VT_SHARD.._Inventory
        WHERE CharID = @CharID
          AND Slot = 13
          AND ItemID > 0
    )
    AND OptLevel BETWEEN 0 AND 7
END
